UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBCJb6o3zRwbAs4jizyvO9W92vVvolIKyYQ/LltQ/U4='
WHERE
key_id = 'af37e7165de197bbd67e553235871a864a073bf21a324b29c23fab59df6f2a63'
AND (
token = 'HBCJb6o3zRwbAs4jizyvO9W92vVvolIKyYQ/LltQ/U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)