UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V2L6xjVPqglnrGvrKZik0wgUE/pfc6ntEdH5nFI2KJc='
WHERE
key_id = '7e97495f14fc767c917ad0c5348ab1fd7f3a187fba5567c4846981f0d6798ceb'
AND (
token = 'V2L6xjVPqglnrGvrKZik0wgUE/pfc6ntEdH5nFI2KJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)