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