UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPBgSCTEDZfaV9OJyW5hvCY2bbyF77O17elZqyuAilU='
WHERE
key_id = '6dd1dafc833c3e42fad259a9e29a0115f31dee4d1ad6b62319d9103d2de3775a'
AND (
token = 'zPBgSCTEDZfaV9OJyW5hvCY2bbyF77O17elZqyuAilU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)