UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zp5dtpkX6eqEH4/VY6BnKZPT4eBwYij8k01D2XDNb+k='
WHERE
key_id = '1e56dc2061f184924fd296e06a1cc9c70d215be46994ee540129c01154f78a94'
AND (
token = 'Zp5dtpkX6eqEH4/VY6BnKZPT4eBwYij8k01D2XDNb+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)