UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zqe7abUi0phiIKaIjDmrzx0carLKsZPX+ZdDutn4QMI='
WHERE
key_id = 'aac199741a40279a1165feea501f6f5cd5aa8a5a22868b6d3007b046f65d4a28'
AND (
token = 'Zqe7abUi0phiIKaIjDmrzx0carLKsZPX+ZdDutn4QMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)