UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIVDtHay9mCWJez29mh+JADe0yCflz0Z+4AXcPcVKNo='
WHERE
key_id = '8c802ceb594f167147cdb82e4bb02fc027bdb7a8cb4488355e0d44581102f937'
AND (
token = 'BIVDtHay9mCWJez29mh+JADe0yCflz0Z+4AXcPcVKNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)