UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0myfIPm/gzUuOHQ8UhxMkS/zAJuPcOnM8pts6RKgMUY='
WHERE
key_id = 'dcd67f0bfed9411b83822bcd31beda51479f67312bd5aef5c7bb20bb01963403'
AND (
token = '0myfIPm/gzUuOHQ8UhxMkS/zAJuPcOnM8pts6RKgMUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)