UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HcL8QFyhd5HtnsPd67C1fY9yWGCFHOqgZ7ptDY22POE='
WHERE
key_id = '6147f194a3e55bf738633bc59ce0c9ce47b8ecd620db3931579cf54f6a64f488'
AND (
token = 'HcL8QFyhd5HtnsPd67C1fY9yWGCFHOqgZ7ptDY22POE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)