UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXcA652YFvmtvDvsnTKlwnle4r7+NyDmneAinTaCPbQ='
WHERE
key_id = '4d3d3c07e97937a73ede7a81bbb297a51fc70aa137b8d5b26acea490e68ab072'
AND (
token = 'PXcA652YFvmtvDvsnTKlwnle4r7+NyDmneAinTaCPbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)