UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yvy7SuoLtgUgwpCC4GlttOnB7wKcwElFmPJO0UVjiyM='
WHERE
key_id = '27724c89a582c7778f6f38643ad2e4e59497a51f107a0f9271a48e36d155d619'
AND (
token = 'Yvy7SuoLtgUgwpCC4GlttOnB7wKcwElFmPJO0UVjiyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)