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