UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iFh/rPVu73kRLFHAm9IuA0hatOCiR59wYXtWrDDK+8='
WHERE
key_id = '870c0af25738fcae3b6322f278b05f38dedcaa7fa6b01caf00f0f50c388f4232'
AND (
token = '3iFh/rPVu73kRLFHAm9IuA0hatOCiR59wYXtWrDDK+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)