UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2nWOjOzlkkPlrX3jRzGCz3IdCyKP4Q59olxmOsnYSw0='
WHERE
key_id = '8931fd50b0c7375725c472fcd02830be76b4129162f86693cca5588d233552ab'
AND (
token = '2nWOjOzlkkPlrX3jRzGCz3IdCyKP4Q59olxmOsnYSw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)