UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkJ+h1SjI595OggYclL8nbQZ+yrj1z8qGigpPYhpVPM='
WHERE
key_id = 'a6450c8b1193c66f5f6340ecdee94fd1a82b62b0a8d985fcf4ebcfd442f6906b'
AND (
token = 'zkJ+h1SjI595OggYclL8nbQZ+yrj1z8qGigpPYhpVPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)