UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9HD3ZBgcOY2J+eUg7Ci3w6efpqDxatcV980I+QHjdWo='
WHERE
key_id = '09d47cf28d622c45c3dc209b86a0b2c1a45c2cd1c50e4baed45c56c3348d39c7'
AND (
token = '9HD3ZBgcOY2J+eUg7Ci3w6efpqDxatcV980I+QHjdWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)