UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9Il3s5i9+LbfLOOnA4ddBp0QTDUQ4IC6z2QGUwontg='
WHERE
key_id = 'ef099a7493c266b511e8116462b5cfa6aa4ffcfb068e605ab57905c81d4491f0'
AND (
token = 'p9Il3s5i9+LbfLOOnA4ddBp0QTDUQ4IC6z2QGUwontg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)