UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Z5CSnWsfuSVaDqmvuM7BUIBtOLq4NFTXIG51d2gDoI='
WHERE
key_id = 'a610ae199eaccf788785dd914ef668bb8e2bdcf175ef0a1d2cbf85b55b1f32d6'
AND (
token = '4Z5CSnWsfuSVaDqmvuM7BUIBtOLq4NFTXIG51d2gDoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)