UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9b0NqJXwynuFXowOVzW9TjscRxT5J0Ltu8L5tOCPaMA='
WHERE
key_id = '0073132b15a3c1cac27d8d30eec25d0a578487d61b4338a2cd0c825a80b9551c'
AND (
token = '9b0NqJXwynuFXowOVzW9TjscRxT5J0Ltu8L5tOCPaMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)