UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9AyYewXJNdK4e2zbKZ7jtf03NvXXPSqAlWfRnB0XCZg='
WHERE
key_id = '35df50eafcfddf5911762decec6c11ec1d6f926f204f56ee272c98636aa8374d'
AND (
token = '9AyYewXJNdK4e2zbKZ7jtf03NvXXPSqAlWfRnB0XCZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)