UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sB1JbZ+2cFli8T4fzNvbnrYLyYQZ86GusK82y/DRN20='
WHERE
key_id = 'd316f8b778ca2aff381cc11d9d71166102443558f95ca0234b5f5a0fd4183258'
AND (
token = 'sB1JbZ+2cFli8T4fzNvbnrYLyYQZ86GusK82y/DRN20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)