UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ty0tgqnA4I2Ux3Ub6gWi91XSpVwGmaNxGxU5Rlxizo='
WHERE
key_id = '374dd812f18a52c1ef8df4b8e657b061f3480d3fef1f2d584633d78a4661f01e'
AND (
token = '2ty0tgqnA4I2Ux3Ub6gWi91XSpVwGmaNxGxU5Rlxizo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)