UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hh5JUgXBTMFIMTKRxmsNYNIfEiMzFzAeAqIbHtLNI0='
WHERE
key_id = '87971c4a0e6517c51f4c6dd34c28f08d3b46ad44f0c3f7a7b7de9101dbe88063'
AND (
token = '9hh5JUgXBTMFIMTKRxmsNYNIfEiMzFzAeAqIbHtLNI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)