UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xl3C5zSq3Yw45jk224veWtMoHP6dsNW6lOHoj4xqysk='
WHERE
key_id = 'bed9edcf9ae673b2db94f05e1dfad1ad9b73af2e901b1efbe5e84653a45ee171'
AND (
token = 'xl3C5zSq3Yw45jk224veWtMoHP6dsNW6lOHoj4xqysk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)