UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNW1kWR/14ri6n1WKZLH9QnD9cHOJBcrJgjVvVFP83w='
WHERE
key_id = '6805e0c98db20421dc810730a04bc10c68f7210cfc3ef621e9db72ebd96c2915'
AND (
token = 'gNW1kWR/14ri6n1WKZLH9QnD9cHOJBcrJgjVvVFP83w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)