UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H0ExQD4PfI5WvkSi98rGYaA67m+zf3ChUdhIt2C2ZuU='
WHERE
key_id = '74cd89eb33f21bbaa6347c5882892bee4024c2344cacb815da5f3700664f673c'
AND (
token = 'H0ExQD4PfI5WvkSi98rGYaA67m+zf3ChUdhIt2C2ZuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)