UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THw0IDtdesF/ZN2MvIUoANA3tI6jOUAqnuxNHeeJp/0='
WHERE
key_id = '66b47a41d5f6b9ee1d4d5a8dfc811de5dad4bb8a0c9d97e2f675f74ebfa2f28e'
AND (
token = 'THw0IDtdesF/ZN2MvIUoANA3tI6jOUAqnuxNHeeJp/0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)