UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3t2RSlNzs6zY+amjNKispC1yfIX78IFg2Mf6hTbGnOs='
WHERE
key_id = '67af3ae5aa7d0c6bc890f8373d33c4c6075b73af11f29adab4155810bfb997e8'
AND (
token = '3t2RSlNzs6zY+amjNKispC1yfIX78IFg2Mf6hTbGnOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)