UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VHFuoC8+HAUb5zmbFL8y/hEeWpohAQis/FRJkdPpMiE='
WHERE
key_id = '053f212a4e638ad8c1b67ae9a8d96547cad4f9d76db8a095a9b8e5b9179fc96f'
AND (
token = 'VHFuoC8+HAUb5zmbFL8y/hEeWpohAQis/FRJkdPpMiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)