UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8I/yQcWxZutliHFAHtWGqy1cbci87HYuvCO8atWAZs0='
WHERE
key_id = '3ab54f99f6de3ba4eb5493bbe94592b229211c21a7840b606e669f7ab8a0c23b'
AND (
token = '8I/yQcWxZutliHFAHtWGqy1cbci87HYuvCO8atWAZs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)