UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFb76RImxHb0ax11OZqKq9SOmm/1ygZ3oRAMyNs5RZw='
WHERE
key_id = 'ca57b1be4916a943feaecc75c920493b49fe701ed8022bf41a49c2a267673dd3'
AND (
token = 'oFb76RImxHb0ax11OZqKq9SOmm/1ygZ3oRAMyNs5RZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)