UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/PmJ88Wi8sBJ0ymkQoymQHg3vZ3YBZXO58RW1n/DGqY='
WHERE
key_id = '4e7707094bb5547f4522bc85ea1b0c1a9be165969e6198e8076af099a56279f2'
AND (
token = '/PmJ88Wi8sBJ0ymkQoymQHg3vZ3YBZXO58RW1n/DGqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)