UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G/tdJ8jtnrqzMbUWzUkDF0o3QUbGJZ5jCZRipsDGcgM='
WHERE
key_id = '05af4bb388d5aca9621a2f1b6993860e787e7d2ff202f52e95c1fc95eaaa3438'
AND (
token = 'G/tdJ8jtnrqzMbUWzUkDF0o3QUbGJZ5jCZRipsDGcgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)