UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H0dKJkXzu4qAoYtVf11sFPrUNlvcrcQBA2UP6wlrD1k='
WHERE
key_id = '6116b73378e2c45d5698b3353c9fbf1a55f77f3cdf45f9ebc0123c5b70513dc3'
AND (
token = 'H0dKJkXzu4qAoYtVf11sFPrUNlvcrcQBA2UP6wlrD1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)